Overview

Brought to you by YData

Dataset statistics

Number of variables	22
Number of observations	180519
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	127.2 MiB
Average record size in memory	738.6 B

Variable types

DateTime	2
Categorical	8
Numeric	8
Text	4

Alerts

`delivery_status` is highly overall correlated with `late_delivery_risk` and 2 other fields	High correlation
`discount` is highly overall correlated with `discount_rate` and 1 other fields	High correlation
`discount_rate` is highly overall correlated with `discount`	High correlation
`late_delivery_risk` is highly overall correlated with `delivery_status` and 1 other fields	High correlation
`order_status` is highly overall correlated with `delivery_status`	High correlation
`product_price` is highly overall correlated with `sales_actual` and 1 other fields	High correlation
`sales_actual` is highly overall correlated with `product_price` and 1 other fields	High correlation
`sales_origin` is highly overall correlated with `discount` and 2 other fields	High correlation
`shipping_days_actual` is highly overall correlated with `delivery_status` and 3 other fields	High correlation
`shipping_days_scheduled` is highly overall correlated with `shipping_days_actual` and 1 other fields	High correlation
`shipping_mode` is highly overall correlated with `shipping_days_actual` and 1 other fields	High correlation
`shipping_days_actual` has 5080 (2.8%) zeros	Zeros
`discount` has 10028 (5.6%) zeros	Zeros
`discount_rate` has 10028 (5.6%) zeros	Zeros

Reproduction

Analysis started	2025-05-05 16:17:38.060093
Analysis finished	2025-05-05 16:18:09.850241
Duration	31.79 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

order_date
Date

Distinct	1127
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Minimum	2015-01-01 00:00:00
Maximum	2018-01-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

shipping_date
Date

Distinct	1131
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Minimum	2015-01-03 00:00:00
Maximum	2018-02-06 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

shipping_mode
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Standard Class	107752
Second Class	35216
First Class	27814
Same Day	9737

Length

Max length	14
Median length	14
Mean length	12.823969
Min length	8

Characters and Unicode

Total characters	2314970
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Standard Class
2nd row	Standard Class
3rd row	Standard Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	107752	59.7%
Second Class	35216	19.5%
First Class	27814	15.4%
Same Day	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	170782	47.3%
standard	107752	29.8%
second	35216	9.8%
first	27814	7.7%
same	9737	2.7%
day	9737	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2314970	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2314970	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2314970	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

delivery_status
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Late delivery	98977
Advance shipping	41592
Shipping on time	32196
Shipping canceled	7754

Length

Max length	17
Median length	13
Mean length	14.39808
Min length	13

Characters and Unicode

Total characters	2599127
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Advance shipping
2nd row	Late delivery
3rd row	Shipping on time
4th row	Advance shipping
5th row	Advance shipping

Common Values

Value	Count	Frequency (%)
Late delivery	98977	54.8%
Advance shipping	41592	23.0%
Shipping on time	32196	17.8%
Shipping canceled	7754	4.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
late	98977	25.2%
delivery	98977	25.2%
shipping	81542	20.7%
advance	41592	10.6%
on	32196	8.2%
time	32196	8.2%
canceled	7754	2.0%

Most occurring characters

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2599127	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2599127	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2599127	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

shipping_days_actual
Real number (ℝ)

High correlation Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.497654

Minimum	0
Maximum	6
Zeros	5080
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6237218
Coefficient of variation (CV)	0.46423169
Kurtosis	-1.0079136
Mean	3.497654
Median Absolute Deviation (MAD)	1
Skewness	0.084771273
Sum	631393
Variance	2.6364726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	56618	31.4%
3	28765	15.9%
6	28723	15.9%
4	28513	15.8%
5	28163	15.6%
0	5080	2.8%
1	4657	2.6%

Value	Count	Frequency (%)
0	5080	2.8%
1	4657	2.6%
2	56618	31.4%
3	28765	15.9%
4	28513	15.8%
5	28163	15.6%
6	28723	15.9%

Value	Count	Frequency (%)
6	28723	15.9%
5	28163	15.6%
4	28513	15.8%
3	28765	15.9%
2	56618	31.4%
1	4657	2.6%
0	5080	2.8%

shipping_days_scheduled
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 MiB

4	107752
2	35216
1	27814
0	9737

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring characters

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

late_delivery_risk
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 MiB

1	98977
0	81542

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring characters

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

sales_origin
Real number (ℝ)

High correlation

Distinct	193
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203.7721

Minimum	9.99
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.99
5-th percentile	49.98
Q1	119.98
median	199.92
Q3	299.95001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	179.97001

Descriptive statistics

Standard deviation	132.27308
Coefficient of variation (CV)	0.64912262
Kurtosis	23.936562
Mean	203.7721
Median Absolute Deviation (MAD)	79.94
Skewness	2.8842491
Sum	36784735
Variance	17496.167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.99001	22372	12.4%
399.98001	17325	9.6%
199.99001	15622	8.7%
299.98001	13729	7.6%
179.97	5016	2.8%
299.95001	4988	2.8%
119.98	4968	2.8%
239.96001	4955	2.7%
59.99	4893	2.7%
50	4432	2.5%
Other values (183)	82219	45.5%

Value	Count	Frequency (%)
9.99	56	< 0.1%
11.29	271	0.2%
11.54	529	0.3%
14.99	124	0.1%
15.99	118	0.1%
17.99	62	< 0.1%
19.98	54	< 0.1%
19.99	176	0.1%
21.99	51	< 0.1%
22	64	< 0.1%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.98999	10	< 0.1%
599.98999	21	< 0.1%
532.58002	484	0.3%
500	15	< 0.1%
499.95001	2510	1.4%
499.75	12	< 0.1%
495	14	< 0.1%
474.95001	15	< 0.1%

sales_actual
Real number (ℝ)

High correlation

Distinct	2927
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	183.10761

Minimum	7.49
Maximum	1939.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.49
5-th percentile	41.5
Q1	104.38
median	163.99001
Q3	247.39999
95-th percentile	383.98001
Maximum	1939.99
Range	1932.5
Interquartile range (IQR)	143.01999

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.65559083
Kurtosis	23.920362
Mean	183.10761
Median Absolute Deviation (MAD)	67.00001
Skewness	2.8884461
Sum	33054402
Variance	14410.483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.84	1264	0.7%
109.19	1247	0.7%
124.79	1243	0.7%
129.99001	1243	0.7%
116.99	1243	0.7%
123.49	1243	0.7%
120.89	1243	0.7%
127.39	1243	0.7%
97.49	1243	0.7%
118.29	1243	0.7%
Other values (2917)	168064	93.1%

Value	Count	Frequency (%)
7.49	3	< 0.1%
7.99	3	< 0.1%
8.19	3	< 0.1%
8.29	3	< 0.1%
8.39	3	< 0.1%
8.47	15	< 0.1%
8.49	3	< 0.1%
8.66	29	< 0.1%
8.69	3	< 0.1%
8.79	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%
1819.98999	1	< 0.1%
1799.98999	1	< 0.1%
1759.98999	1	< 0.1%
1739.98999	1	< 0.1%
1699.98999	1	< 0.1%

profit_per_order
Real number (ℝ)

Distinct	21998
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.974989

Minimum	-4274.98
Maximum	911.8
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.98
5-th percentile	-139.251
Q1	7
median	31.52
Q3	64.8
95-th percentile	132.29
Maximum	911.8
Range	5186.78
Interquartile range (IQR)	57.8

Descriptive statistics

Standard deviation	104.43353
Coefficient of variation (CV)	4.7523813
Kurtosis	71.377259
Mean	21.974989
Median Absolute Deviation (MAD)	27.88
Skewness	-4.7418341
Sum	3966903
Variance	10906.361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1177	0.7%
143.99	199	0.1%
72	194	0.1%
46.8	188	0.1%
24	181	0.1%
18	175	0.1%
63.7	172	0.1%
62.4	168	0.1%
12	166	0.1%
14.4	166	0.1%
Other values (21988)	177733	98.5%

Value	Count	Frequency (%)
-4274.98	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%
-2550	1	< 0.1%
-2351.25	1	< 0.1%
-2328	1	< 0.1%
-2280	1	< 0.1%
-2255.25	1	< 0.1%

Value	Count	Frequency (%)
911.8	1	< 0.1%
864	1	< 0.1%
721.6	1	< 0.1%
720.3	1	< 0.1%
720	2	< 0.1%
712.95	1	< 0.1%
708.75	1	< 0.1%
705.6	2	< 0.1%
705	1	< 0.1%
698.4	2	< 0.1%

customer_segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Consumer	93504
Corporate	54789
Home Office	32226

Length

Max length	11
Median length	8
Mean length	8.839064
Min length	8

Characters and Unicode

Total characters	1595619
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Consumer
4th row	Home Office
5th row	Corporate

Common Values

Value	Count	Frequency (%)
Consumer	93504	51.8%
Corporate	54789	30.4%
Home Office	32226	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	93504	44.0%
corporate	54789	25.8%
home	32226	15.1%
office	32226	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1595619	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1595619	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1595619	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

order_city
Text

Distinct	3596
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Length

Max length	35
Median length	29
Mean length	8.553781
Min length	2

Characters and Unicode

Total characters	1544120
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	69 ?
Unique (%)	< 0.1%

Sample

1st row	Bekasi
2nd row	Bikaner
3rd row	Bikaner
4th row	Townsville
5th row	Townsville

Value	Count	Frequency (%)
san	6508	2.9%
city	5626	2.5%
de	3211	1.4%
los	2435	1.1%
santo	2339	1.0%
new	2316	1.0%
york	2316	1.0%
domingo	2239	1.0%
angeles	1873	0.8%
tegucigalpa	1783	0.8%
Other values (3762)	197254	86.6%

Most occurring characters

Value	Count	Frequency (%)
a	203359	13.2%
e	117976	7.6%
n	115253	7.5%
o	113469	7.3%
i	98628	6.4%
r	85703	5.6%
l	76707	5.0%
u	59359	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (50)	561159	36.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1544120	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	203359	13.2%
e	117976	7.6%
n	115253	7.5%
o	113469	7.3%
i	98628	6.4%
r	85703	5.6%
l	76707	5.0%
u	59359	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (50)	561159	36.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1544120	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	203359	13.2%
e	117976	7.6%
n	115253	7.5%
o	113469	7.3%
i	98628	6.4%
r	85703	5.6%
l	76707	5.0%
u	59359	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (50)	561159	36.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1544120	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	203359	13.2%
e	117976	7.6%
n	115253	7.5%
o	113469	7.3%
i	98628	6.4%
r	85703	5.6%
l	76707	5.0%
u	59359	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (50)	561159	36.3%

order_country
Text

Distinct	164
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Length

Max length	31
Median length	22
Mean length	8.7728272
Min length	4

Characters and Unicode

Total characters	1583662
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Indonesia
2nd row	India
3rd row	India
4th row	Australia
5th row	Australia

Value	Count	Frequency (%)
unidos	24869	10.8%
estados	24840	10.8%
francia	13222	5.7%
mexico	13172	5.7%
alemania	9564	4.1%
australia	8497	3.7%
brasil	7987	3.5%
reino	7302	3.2%
unido	7302	3.2%
china	5758	2.5%
Other values (175)	108034	46.9%

Most occurring characters

Value	Count	Frequency (%)
a	248092	15.7%
i	173374	10.9%
n	123666	7.8%
s	117962	7.4%
o	110463	7.0%
d	83403	5.3%
e	67560	4.3%
r	66669	4.2%
l	62119	3.9%
t	50532	3.2%
Other values (44)	479822	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1583662	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	248092	15.7%
i	173374	10.9%
n	123666	7.8%
s	117962	7.4%
o	110463	7.0%
d	83403	5.3%
e	67560	4.3%
r	66669	4.2%
l	62119	3.9%
t	50532	3.2%
Other values (44)	479822	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1583662	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	248092	15.7%
i	173374	10.9%
n	123666	7.8%
s	117962	7.4%
o	110463	7.0%
d	83403	5.3%
e	67560	4.3%
r	66669	4.2%
l	62119	3.9%
t	50532	3.2%
Other values (44)	479822	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1583662	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	248092	15.7%
i	173374	10.9%
n	123666	7.8%
s	117962	7.4%
o	110463	7.0%
d	83403	5.3%
e	67560	4.3%
r	66669	4.2%
l	62119	3.9%
t	50532	3.2%
Other values (44)	479822	30.3%

order_region
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Central America	28341
Western Europe	27109
South America	14935
Oceania	10148
Northern Europe	9792
Other values (18)	90194

Length

Max length	15
Median length	14
Mean length	12.535007
Min length	6

Characters and Unicode

Total characters	2262807
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Southeast Asia
2nd row	South Asia
3rd row	South Asia
4th row	Oceania
5th row	Oceania

Common Values

Value	Count	Frequency (%)
Central America	28341	15.7%
Western Europe	27109	15.0%
South America	14935	8.3%
Oceania	10148	5.6%
Northern Europe	9792	5.4%
Southeast Asia	9539	5.3%
Southern Europe	9431	5.2%
Caribbean	8318	4.6%
West of USA	7993	4.4%
South Asia	7731	4.3%
Other values (13)	47182	26.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
europe	50252	13.9%
america	43276	12.0%
asia	31112	8.6%
central	30571	8.5%
western	27109	7.5%
south	26711	7.4%
of	18953	5.3%
usa	18953	5.3%
west	17698	4.9%
africa	11614	3.2%
Other values (11)	84317	23.4%

Most occurring characters

Value	Count	Frequency (%)
e	267374	11.8%
r	221631	9.8%
a	185888	8.2%
	184092	8.1%
t	170633	7.5%
o	129067	5.7%
n	114572	5.1%
s	105425	4.7%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2262807	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	267374	11.8%
r	221631	9.8%
a	185888	8.2%
	184092	8.1%
t	170633	7.5%
o	129067	5.7%
n	114572	5.1%
s	105425	4.7%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2262807	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	267374	11.8%
r	221631	9.8%
a	185888	8.2%
	184092	8.1%
t	170633	7.5%
o	129067	5.7%
n	114572	5.1%
s	105425	4.7%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2262807	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	267374	11.8%
r	221631	9.8%
a	185888	8.2%
	184092	8.1%
t	170633	7.5%
o	129067	5.7%
n	114572	5.1%
s	105425	4.7%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.8%

order_state
Text

Distinct	1089
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	11.7 MiB

Length

Max length	36
Median length	31
Mean length	10.868086
Min length	3

Characters and Unicode

Total characters	1961896
Distinct characters	59
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	Java Occidental
2nd row	Rajastan
3rd row	Rajastan
4th row	Queensland
5th row	Queensland

Value	Count	Frequency (%)
de	9121	3.5%
del	8417	3.2%
inglaterra	6722	2.6%
california	5580	2.1%
nueva	5473	2.1%
isla	4667	1.8%
francia	4580	1.7%
san	3965	1.5%
sur	3354	1.3%
renania	3303	1.3%
Other values (1167)	208183	79.0%

Most occurring characters

Value	Count	Frequency (%)
a	322907	16.5%
n	145815	7.4%
i	143282	7.3%
e	134534	6.9%
o	119614	6.1%
r	117395	6.0%
l	103549	5.3%
	82846	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (49)	636240	32.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1961896	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	322907	16.5%
n	145815	7.4%
i	143282	7.3%
e	134534	6.9%
o	119614	6.1%
r	117395	6.0%
l	103549	5.3%
	82846	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (49)	636240	32.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1961896	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	322907	16.5%
n	145815	7.4%
i	143282	7.3%
e	134534	6.9%
o	119614	6.1%
r	117395	6.0%
l	103549	5.3%
	82846	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (49)	636240	32.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1961896	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	322907	16.5%
n	145815	7.4%
i	143282	7.3%
e	134534	6.9%
o	119614	6.1%
r	117395	6.0%
l	103549	5.3%
	82846	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (49)	636240	32.4%

order_status
Categorical

High correlation

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.5 MiB

COMPLETE	59491
PENDING_PAYMENT	39832
PROCESSING	21902
PENDING	20227
CLOSED	19616
Other values (4)	19451

Length

Max length	15
Median length	14
Mean length	9.6239676
Min length	6

Characters and Unicode

Total characters	1737309
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COMPLETE
2nd row	PENDING
3rd row	CLOSED
4th row	COMPLETE
5th row	PENDING_PAYMENT

Common Values

Value	Count	Frequency (%)
COMPLETE	59491	33.0%
PENDING_PAYMENT	39832	22.1%
PROCESSING	21902	12.1%
PENDING	20227	11.2%
CLOSED	19616	10.9%
ON_HOLD	9804	5.4%
SUSPECTED_FRAUD	4062	2.3%
CANCELED	3692	2.0%
PAYMENT_REVIEW	1893	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	59491	33.0%
pending_payment	39832	22.1%
processing	21902	12.1%
pending	20227	11.2%
closed	19616	10.9%
on_hold	9804	5.4%
suspected_fraud	4062	2.3%
canceled	3692	2.0%
payment_review	1893	1.0%

Most occurring characters

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1737309	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1737309	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1737309	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

order_item_qty
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.0 MiB

1	99134
5	20385
3	20350
4	20335
2	20315

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring characters

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	180519	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

discount
Real number (ℝ)

High correlation Zeros

Distinct	1017
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.664741

Minimum	0
Maximum	500
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5.4
median	14
Q3	29.99
95-th percentile	62.5
Maximum	500
Range	500
Interquartile range (IQR)	24.59

Descriptive statistics

Standard deviation	21.800901
Coefficient of variation (CV)	1.0549806
Kurtosis	25.231267
Mean	20.664741
Median Absolute Deviation (MAD)	10
Skewness	3.0397955
Sum	3730378.4
Variance	475.27928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10028	5.6%
6	4589	2.5%
12	4067	2.3%
4	3647	2.0%
8	3626	2.0%
10	3424	1.9%
36	3268	1.8%
30	3230	1.8%
20	3123	1.7%
9	2964	1.6%
Other values (1007)	138553	76.8%

Value	Count	Frequency (%)
0	10028	5.6%
0.1	3	< 0.1%
0.11	15	< 0.1%
0.12	29	< 0.1%
0.15	7	< 0.1%
0.16	7	< 0.1%
0.18	3	< 0.1%
0.2	16	< 0.1%
0.22	6	< 0.1%
0.23	44	< 0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
400	1	< 0.1%
375	25	< 0.1%
360	1	< 0.1%
340	1	< 0.1%
320	1	< 0.1%
300	26	< 0.1%
270	25	< 0.1%
260	1	< 0.1%
255	25	< 0.1%

discount_rate
Real number (ℝ)

High correlation Zeros

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10166819

Minimum	0
Maximum	0.25
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.04
median	0.1
Q3	0.16
95-th percentile	0.25
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.12

Descriptive statistics

Standard deviation	0.070415215
Coefficient of variation (CV)	0.69259829
Kurtosis	-0.90115683
Mean	0.10166819
Median Absolute Deviation (MAD)	0.06
Skewness	0.3409276
Sum	18353.04
Variance	0.0049583024
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0.04	10029	5.6%
0.15	10029	5.6%
0.25	10029	5.6%
0.2	10029	5.6%
0.18	10029	5.6%
0.17	10029	5.6%
0.05	10029	5.6%
0.16	10029	5.6%
0.13	10029	5.6%
0.12	10029	5.6%
Other values (8)	80229	44.4%

Value	Count	Frequency (%)
0	10028	5.6%
0.01	10028	5.6%
0.02	10028	5.6%
0.03	10029	5.6%
0.04	10029	5.6%
0.05	10029	5.6%
0.06	10029	5.6%
0.07	10029	5.6%
0.09	10029	5.6%
0.1	10029	5.6%

Value	Count	Frequency (%)
0.25	10029	5.6%
0.2	10029	5.6%
0.18	10029	5.6%
0.17	10029	5.6%
0.16	10029	5.6%
0.15	10029	5.6%
0.13	10029	5.6%
0.12	10029	5.6%
0.1	10029	5.6%
0.09	10029	5.6%

product_id
Real number (ℝ)

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.851451

Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.640064
Coefficient of variation (CV)	0.49103145
Kurtosis	-0.60326101
Mean	31.851451
Median Absolute Deviation (MAD)	14
Skewness	0.3616248
Sum	5749792
Variance	244.6116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%
7	614	0.3%
9	12487	6.9%
10	111	0.1%
11	309	0.2%
12	423	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%
71	434	0.2%
70	208	0.1%
69	362	0.2%
68	484	0.3%
67	483	0.3%

product_name
Text

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.9 MiB

Length

Max length	45
Median length	43
Mean length	35.110177
Min length	4

Characters and Unicode

Total characters	6338054
Distinct characters	66
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Smart watch
2nd row	Smart watch
3rd row	Smart watch
4th row	Smart watch
5th row	Smart watch

Value	Count	Frequency (%)
men's	77602	7.3%
nike	57309	5.4%
perfect	49030	4.6%
golf	26281	2.5%
rip	24515	2.3%
deck	24515	2.3%
fitness	24515	2.3%
cleat	22813	2.1%
2	22574	2.1%
elite	22309	2.1%
Other values (351)	715106	67.0%

Most occurring characters

Value	Count	Frequency (%)
	886050	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6338054	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	886050	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6338054	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	886050	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6338054	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	886050	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

product_price
Real number (ℝ)

High correlation

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141.23255

Minimum	9.99
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.99
5-th percentile	31.99
Q1	50
median	59.99
Q3	199.99
95-th percentile	399.98
Maximum	1999.99
Range	1990
Interquartile range (IQR)	149.99

Descriptive statistics

Standard deviation	139.73249
Coefficient of variation (CV)	0.98937881
Kurtosis	23.313
Mean	141.23255
Median Absolute Deviation (MAD)	40
Skewness	3.1910197
Sum	25495158
Variance	19525.168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.99	24820	13.7%
129.99	22372	12.4%
50	21035	11.7%
49.98	19298	10.7%
399.98	17325	9.6%
199.99	15622	8.7%
299.98	13729	7.6%
99.99	12433	6.9%
39.99	11201	6.2%
24.99	2339	1.3%
Other values (65)	20345	11.3%

Value	Count	Frequency (%)
9.99	285	0.2%
11.29	271	0.2%
11.54	529	0.3%
14.99	593	0.3%
15.99	602	0.3%
17.99	298	0.2%
19.99	887	0.5%
21.99	295	0.2%
22	308	0.2%
24.99	2339	1.3%

Value	Count	Frequency (%)
1999.99	15	< 0.1%
1500	442	0.2%
999.99	10	< 0.1%
599.99	21	< 0.1%
532.58	484	0.3%
461.48	484	0.3%
452.04	592	0.3%
399.99	67	< 0.1%
399.98	17325	9.6%
357.1	652	0.4%

Interactions

Correlations

	customer_segment	delivery_status	discount	discount_rate	late_delivery_risk	order_item_qty	order_region	order_status	product_id	product_price	profit_per_order	sales_actual	sales_origin	shipping_days_actual	shipping_days_scheduled	shipping_mode
customer_segment	1.000	0.005	0.002	0.002	0.000	0.004	0.017	0.011	0.008	0.002	0.000	0.006	0.004	0.009	0.008	0.008
delivery_status	0.005	1.000	0.000	0.003	1.000	0.000	0.018	0.577	0.000	0.000	0.000	0.005	0.000	0.561	0.321	0.321
discount	0.002	0.000	1.000	0.795	0.000	0.082	0.018	0.000	0.073	0.356	0.196	0.420	0.534	0.001	0.000	0.000
discount_rate	0.002	0.003	0.795	1.000	0.005	0.000	0.000	0.003	0.000	0.000	-0.054	-0.133	0.000	0.001	0.000	0.000
late_delivery_risk	0.000	1.000	0.000	0.005	1.000	0.000	0.017	0.234	0.000	0.004	0.000	0.000	0.002	0.631	0.457	0.457
order_item_qty	0.004	0.000	0.082	0.000	0.000	1.000	0.031	0.000	0.232	0.229	0.034	0.212	0.235	0.000	0.002	0.002
order_region	0.017	0.018	0.018	0.000	0.017	0.031	1.000	0.017	0.118	0.060	0.014	0.026	0.042	0.022	0.023	0.023
order_status	0.011	0.577	0.000	0.003	0.234	0.000	0.017	1.000	0.001	0.003	0.000	0.006	0.004	0.008	0.009	0.009
product_id	0.008	0.000	0.073	0.000	0.000	0.232	0.118	0.001	1.000	0.195	0.061	0.162	0.178	-0.002	0.009	0.009
product_price	0.002	0.000	0.356	0.000	0.004	0.229	0.060	0.003	0.195	1.000	0.287	0.639	0.667	-0.000	0.008	0.008
profit_per_order	0.000	0.000	0.196	-0.054	0.000	0.034	0.014	0.000	0.061	0.287	1.000	0.441	0.436	-0.003	0.002	0.002
sales_actual	0.006	0.005	0.420	-0.133	0.000	0.212	0.026	0.006	0.162	0.639	0.441	1.000	0.986	-0.000	0.004	0.004
sales_origin	0.004	0.000	0.534	0.000	0.002	0.235	0.042	0.004	0.178	0.667	0.436	0.986	1.000	-0.000	0.006	0.006
shipping_days_actual	0.009	0.561	0.001	0.001	0.631	0.000	0.022	0.008	-0.002	-0.000	-0.003	-0.000	-0.000	1.000	0.681	0.681
shipping_days_scheduled	0.008	0.321	0.000	0.000	0.457	0.002	0.023	0.009	0.009	0.008	0.002	0.004	0.006	0.681	1.000	1.000
shipping_mode	0.008	0.321	0.000	0.000	0.457	0.002	0.023	0.009	0.009	0.008	0.002	0.004	0.006	0.681	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	order_date	shipping_date	shipping_mode	delivery_status	shipping_days_actual	shipping_days_scheduled	late_delivery_risk	sales_origin	sales_actual	profit_per_order	customer_segment	order_city	order_country	order_region	order_state	order_status	order_item_qty	discount	discount_rate	product_id	product_name	product_price
0	2018-01-31	2018-02-03	Standard Class	Advance shipping	3	4	0	327.75	314.64001	91.25	Consumer	Bekasi	Indonesia	Southeast Asia	Java Occidental	COMPLETE	1	13.11	0.04	73	Smart watch	327.75
1	2018-01-13	2018-01-18	Standard Class	Late delivery	5	4	1	327.75	311.35999	-249.09	Consumer	Bikaner	India	South Asia	Rajastan	PENDING	1	16.39	0.05	73	Smart watch	327.75
2	2018-01-13	2018-01-17	Standard Class	Shipping on time	4	4	0	327.75	309.72000	-247.78	Consumer	Bikaner	India	South Asia	Rajastan	CLOSED	1	18.03	0.06	73	Smart watch	327.75
3	2018-01-13	2018-01-16	Standard Class	Advance shipping	3	4	0	327.75	304.81000	22.86	Home Office	Townsville	Australia	Oceania	Queensland	COMPLETE	1	22.94	0.07	73	Smart watch	327.75
4	2018-01-13	2018-01-15	Standard Class	Advance shipping	2	4	0	327.75	298.25000	134.21	Corporate	Townsville	Australia	Oceania	Queensland	PENDING_PAYMENT	1	29.50	0.09	73	Smart watch	327.75
5	2018-01-13	2018-01-19	Standard Class	Shipping canceled	6	4	0	327.75	294.98001	18.58	Consumer	Toowoomba	Australia	Oceania	Queensland	CANCELED	1	32.78	0.10	73	Smart watch	327.75
6	2018-01-13	2018-01-15	First Class	Late delivery	2	1	1	327.75	288.42001	95.18	Home Office	Guangzhou	China	Eastern Asia	Guangdong	COMPLETE	1	39.33	0.12	73	Smart watch	327.75
7	2018-01-13	2018-01-15	First Class	Late delivery	2	1	1	327.75	285.14001	68.43	Corporate	Guangzhou	China	Eastern Asia	Guangdong	PROCESSING	1	42.61	0.13	73	Smart watch	327.75
8	2018-01-13	2018-01-16	Second Class	Late delivery	3	2	1	327.75	278.59000	133.72	Corporate	Guangzhou	China	Eastern Asia	Guangdong	CLOSED	1	49.16	0.15	73	Smart watch	327.75
9	2018-01-13	2018-01-15	First Class	Late delivery	2	1	1	327.75	275.31000	132.15	Corporate	Guangzhou	China	Eastern Asia	Guangdong	CLOSED	1	52.44	0.16	73	Smart watch	327.75

	order_date	shipping_date	shipping_mode	delivery_status	shipping_days_actual	shipping_days_scheduled	late_delivery_risk	sales_origin	sales_actual	profit_per_order	customer_segment	order_city	order_country	order_region	order_state	order_status	order_item_qty	discount	discount_rate	product_id	product_name	product_price
180509	2016-01-16	2016-01-19	Standard Class	Advance shipping	3	4	0	399.98001	335.98001	0.00	Corporate	Guangshui	China	Eastern Asia	Hubei	PENDING_PAYMENT	1	64.0	0.16	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180510	2016-01-16	2016-01-19	Standard Class	Advance shipping	3	4	0	399.98001	331.98001	165.99	Corporate	Guangshui	China	Eastern Asia	Hubei	PENDING_PAYMENT	1	68.0	0.17	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180511	2016-01-16	2016-01-18	Second Class	Shipping on time	2	2	0	399.98001	327.98001	157.43	Consumer	Chengdu	China	Eastern Asia	Sichuan	ON_HOLD	1	72.0	0.18	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180512	2016-01-16	2016-01-22	Standard Class	Late delivery	6	4	1	399.98001	319.98001	86.40	Home Office	Chengdu	China	Eastern Asia	Sichuan	COMPLETE	1	80.0	0.20	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180513	2016-01-16	2016-01-19	Standard Class	Advance shipping	3	4	0	399.98001	299.98999	119.99	Home Office	Shanghai	China	Eastern Asia	Shanghai	PENDING_PAYMENT	1	100.0	0.25	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180514	2016-01-16	2016-01-20	Standard Class	Shipping on time	4	4	0	399.98001	399.98001	40.00	Home Office	Shanghai	China	Eastern Asia	Shanghai	CLOSED	1	0.0	0.00	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180515	2016-01-16	2016-01-19	Second Class	Late delivery	3	2	1	399.98001	395.98001	-613.77	Corporate	Hirakata	Japon	Eastern Asia	Osaka	COMPLETE	1	4.0	0.01	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180516	2016-01-15	2016-01-20	Standard Class	Late delivery	5	4	1	399.98001	391.98001	141.11	Corporate	Adelaide	Australia	Oceania	Australia del Sur	PENDING	1	8.0	0.02	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180517	2016-01-15	2016-01-18	Standard Class	Advance shipping	3	4	0	399.98001	387.98001	186.23	Consumer	Adelaide	Australia	Oceania	Australia del Sur	PENDING_PAYMENT	1	12.0	0.03	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98
180518	2016-01-15	2016-01-19	Standard Class	Shipping on time	4	4	0	399.98001	383.98001	168.95	Consumer	Nagercoil	India	South Asia	Tamil Nadu	PENDING_PAYMENT	1	16.0	0.04	45	Field & Stream Sportsman 16 Gun Fire Safe	399.98

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category